﻿CREATE TABLE [dbo].[Escola]
(
	[esc_cod] INT NOT NULL PRIMARY KEY, 
    [esc_nome] VARCHAR(40) NOT NULL, 
    [esc_telefone] INT NOT NULL, 
    [esc_endereco] INT NOT NULL,
	[esc_professor] INT NOT NULL,
	FOREIGN KEY (esc_endereco) references Endereco,
	FOREIGN KEY (esc_professor) references Professor
)
